Course objectives:
|
In this lecture students learn basic informations, needed in following studium. Students will learn work with spreadsheets, they'll get informations about text processing and creating web pages, they'll learn about OS MS Windows's user interface.
|
Requirements on student
|
Credit:
Students have to successfully submit specified seminar work.
Deadline: 31.1.2023.
Students in the combined form of study must reach at least 60% of the possible points in the practical test, which is performed on a computer. The basis for the test is surrendered in advance and approved by the independent work (homework - see methodical instructions).
The deadline for meeting the requirements of the credit is 31.1.2024.
Examination:
A written examination. It is necessary to obtain at least minimum amount of points (60%).
|
Content
|
1. Basic concepts of informatics. Data, information, knowledge. Introduction to data processing.
2. Import and export of data using a spreadsheet.
3. Graphs and analytical tools in a spreadsheet environment.
4. Data structures, basic concepts of algorithms and programming.
5. Technical means and software of computers.
6. Computer networks, security and data protection. Related laws.
|
Activities
|
|
Fields of study
|
Studentům jsou k dispozici webové stránky (na Courseware) se všemy podstatnými informacemi a materiály (slajdy z přednášek, příklady na cvičení atd.)
|
Guarantors and lecturers
|
-
Guarantors:
Ing. Tomáš Potužák, Ph.D. ,
-
Lecturer:
Doc. Dr. Ing. Jana Klečková (100%),
Ing. Tomáš Potužák, Ph.D. (100%),
-
Tutorial lecturer:
Ing. Petr Brůha (100%),
Ing. Zuzana Káčereková (100%),
Doc. Dr. Ing. Jana Klečková (100%),
Ing. Alex König (100%),
Ing. Jana Krutišová (100%),
Ing. Ladislav Lenc, Ph.D. (100%),
Ing. Tomáš Potužák, Ph.D. (100%),
Ing. Jakub Šmíd (100%),
|
Literature
|
|
Time requirements
|
All forms of study
|
Activities
|
Time requirements for activity [h]
|
Contact hours
|
39
|
Preparation for an examination (30-60)
|
30
|
Preparation for formative assessments (2-20)
|
10
|
Total
|
79
|
|
Prerequisites
|
Knowledge - students are expected to possess the following knowledge before the course commences to finish it successfully: |
basic knowledge of computers principle |
basic knowledge of the user interface of MS Windows |
knowledge of extracting information from electronic sources |
basic knowledge of working with a word processor |
basic knowledge of creating a presentation in the environment of the presentation program |
Skills - students are expected to possess the following skills before the course commences to finish it successfully: |
basic skill work with computer |
backup files |
use basic safety rules with electronic resources (username, password) |
basic skills in a word processor environment |
create a simple presentation |
Competences - students are expected to possess the following competences before the course commences to finish it successfully: |
N/A |
N/A |
N/A |
|
Learning outcomes
|
Knowledge - knowledge resulting from the course: |
knowledge of the principle spreadsheet |
knowledge of the creation of the large document |
knowledge presentation and visualization of results at the required level |
good knowledge of fundamental terms in information technology area |
Skills - skills resulting from the course: |
calculations using formulas and functions in standard spreadsheet environment |
create the large document |
presentation of results in environmental presentation program |
ability to search and processing data. |
Competences - competences resulting from the course: |
N/A |
|
Assessment methods
|
Knowledge - knowledge achieved by taking this course are verified by the following means: |
Written exam |
Test |
Seminar work |
Skills - skills achieved by taking this course are verified by the following means: |
Combined exam |
Test |
Seminar work |
Competences - competence achieved by taking this course are verified by the following means: |
Combined exam |
|
Teaching methods
|
Knowledge - the following training methods are used to achieve the required knowledge: |
Lecture |
Practicum |
Individual study |
Skills - the following training methods are used to achieve the required skills: |
Lecture |
Practicum |
Competences - the following training methods are used to achieve the required competences: |
Lecture |
Practicum |
|